IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spCratosProject_Retrieve')
	BEGIN
		PRINT 'Dropping Procedure spCratosProject_Retrieve'
		DROP  Procedure  spCratosProject_Retrieve
	END

GO

PRINT 'Creating Procedure spProject_Retrieve'
GO
CREATE Procedure dbo.spCratosProject_Retrieve
	(
		@CratosProject_ID	bigint
	)
AS
	/* 
		------------------------------------------------------------------------------
		- Change History
		- --------------
		- Date                 Description
		------------------------------------------------------------------------------
		- 25/06/2010 13:45:27  Initial version created
		------------------------------------------------------------------------------
	*/

	-- Declare the required variables

	-- Retrieve the required record
	SELECT  *
	FROM    [CratosProject]
	WHERE		[CratosProject].[CratosProject_ID] = @CratosProject_ID

	-- Return to calling method
	RETURN 

GO
